prepare("SELECT * FROM promoted WHERE (accademic_year = :ac AND class_id = :st)"); $sql->bindparam(":ac", $_SESSION['pyr']); $sql->bindparam(":st", $_SESSION['pclassid']); $sql->execute(); $ct = 0; while($row = $sql->fetch(PDO::FETCH_ASSOC)) { $ct++; $rg = $row['regno']; $stnames[] = $rg; $getname = $DBcon->prepare("SELECT * FROM students_info WHERE (regno = :r)"); $getname->bindparam(":r", $rg); $getname->execute(); $rown = $getname->fetch(PDO::FETCH_ASSOC); $fullname = $rown['fullname']; ?> 0) { ?>

#	REG NO	STUDENT NAME	ACTION
			Remove
No students found in for the academic year.
Total Students: View Another Class